StudentBillingStatementBatch

EntityType | Independent
Logical Entity Name | StudentBillingStatementBatch
Default Table Name | SaBillingStatementBatchStudent
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentBillingStatementBatch Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentBillingStatementBatchId |  | INTEGER | NO |
StudentEnrollmentPeriodId |  | INTEGER | NO |
StudentId |  | INTEGER | NO |
TermId |  | INTEGER | YES |
StudentName |  | VARCHAR(100) | YES |
NameStudent |  | VARCHAR(100) | YES |
PrintIdentifier |  | VARCHAR(16) | YES |
ProgramVersionName |  | VARCHAR(120) | YES |
ExpectedStartDate |  | DATETIME | YES |
AccountReceivableBalance |  | MONEY(19, 4) | NO |
GraduationDate |  | DATETIME | YES |
EstimatedFunding |  | MONEY(19, 4) | NO |
Charges |  | MONEY(19, 4) | NO |
PendingCharges |  | MONEY(19, 4) | NO |
CampusId |  | INTEGER | NO |
IsOverallBalancePrinted |  | BIT | YES |
IsClassSchedulePrinted |  | BIT | YES |
IsPaymentDueDatePrinted |  | BIT | YES |
PaymentDueDate |  | DATETIME | YES |
IsAddDropDatePrinted |  | BIT | YES |
AddDropDate |  | DATETIME | YES |
IsExpectedFundingPrinted |  | BIT | YES |
ExpectedFundingTermId |  | INTEGER | YES |
StatementComment |  | VARCHAR(1000) | YES |
RegistrationComment |  | VARCHAR(1000) | YES |
IsStudentAddressPrinted |  | BIT | YES |
IsEnrollmentInformationPrinted |  | BIT | YES |
ScheduleTermId |  | INTEGER | YES |
IsLedgerCardPrinted |  | BIT | YES |
ClosingDate |  | DATETIME | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
StudentAcademicYearPaymentPeriodId |  | INTEGER | YES |
IsRegDetailReport |  | BIT | YES |
IsSubsidiaryPrinted |  | BIT | YES |
IsConnectedEnrollmentPrinted |  | BIT | NO |
ConnectedStudentEnrollmentPeriodId |  | INTEGER | YES |
ConnectedProgramVersionName |  | VARCHAR(120) | YES |
ConnectedExpectedStartDate |  | DATETIME | YES |
ConnectedGraduationDate |  | DATETIME | YES |
ConnectedTermId |  | INTEGER | YES |
ConnectedStudentAcademicYearPaymentPeriodId |  | INTEGER | YES |
ReportVersion |  | INTEGER | YES |
TransactionBeginDate |  | DATETIME | YES |
TransactionEndDate |  | DATETIME | YES |
StudentId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |

StudentBillingStatementBatch Keys

Key Name | Key Type | Keys
saBillingStatementBatchStudent_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId
saBillingStatementBatchStudent_ClosingDate_N_N_IDX | Inversion Entry | ClosingDate
SaBillingStatementBatchStudent_SyStudentID_N_N_IDX | Inversion Entry | StudentId
saBillingStatementBatchStudent_AdEnrollID_N_N_IDX | Inversion Entry | StudentEnrollmentPeriodId
PK_SaBillingStatementBatchStudent_SaBillingStatementBatchStudentID | PrimaryKey | StudentBillingStatementBatchId

StudentBillingStatementBatch Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | CampusId | NO
StudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO
StudentAcademicYearPaymentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAcademicYearPaymentPeriodId | NO
Campus | Non-Identifying | One To Zero or More |  |  |  | CampusId | NO
Student | Non-Identifying | One To Zero or More |  |  |  | StudentId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
StudentBillingStatementBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaBillingStatementBatchTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaBillingStatementBatchDetailCharges | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaBillingStatementBatchDetailFA | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaBillingStatementBatchDetailPayments | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaBillingStatementBatchSubsidiaryDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentBillingStatementBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentBillingStatementBatch Check Constraints

Check Constraint Name | CheckConstraint

StudentBillingStatementBatch Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentBillingStatementBatch | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaBillingStatementBatchStudent | NO |  |  |

StudentBillingStatementBatch Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | LedgerCard_Billing
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

StudentBillingStatementBatch Data Movement Rules

Name | Type | Rule Text/Value